package com.example.simplecardtenantbank.repository;

import com.example.simplecardtenantbank.dataobject.TBankbillShoppingsheet;
import com.example.simplecardtenantbank.form.ConsumeDetailForm;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TBankbillShoppingsheetRepository {
    @Select("select * from t_bankbill_shoppingsheet where userId = #{userId}")
    public List<TBankbillShoppingsheet> findByUserId(String userId);

    @Select("select * from t_bankbill_shoppingsheet where billId=#{billId} and billMonth=#{billMonth}")
    public List<TBankbillShoppingsheet> findByBillId(ConsumeDetailForm consumeDetailForm);
}
